package com.service;

import com.aop.SystemLog;
import com.dto.DTO;
import com.entity.Sc;
import com.entity.Student;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

public interface StudentService {
    /**
     * 查询全部学生
     * @return
     */
    public DTO<Student> getAllStudents() throws Exception;
    /**
     *  查询学生带选课
     * @param sno
     * @return
     */
    public DTO<Student> selectBySnoWithScs( String sno) throws Exception;
    /**
     *  查询学生带班级
     * @param sno
     * @return
     */
    public DTO<Student> selectBySnoWithClazz(String sno) throws Exception;
    /**
     *  查询学生带选课
     * @param sno
     * @return
     */
    public DTO<Student> selectBySnoWithScsAndClazz( String sno) throws Exception;
    /**
     *  查询学生带选课和课程
     * @param sno
     * @return
     */
    public DTO<Student> selectBySnoWithScsAndCourse(String sno) throws Exception;
    /**
     *  查询学生带班级和班主任
     * @param sno
     * @return
     */

    public DTO<Student> selectBySnoWithClazzANDTeacher( String sno) throws Exception;
    /**
     *  删除学生
     * @param sno
     * @return
     */
    public DTO<Student> deleteStudentBySno(String sno) throws Exception;
    /**
     *  删除学生
     * @param student
     * @return
     */
    public DTO<Student> updateStudentBySno(Student student)  throws Exception;
    /**
     *  增加学生
     * @param student
     * @return
     */
    public DTO<Student> addStudentBySno(Student student)  throws Exception;


    public DTO<Student> addSC(Sc sc) throws Exception;


}
